﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Data.Common;
using Microsoft.Practices.EnterpriseLibrary.Data;

namespace Zxb.DayWork.Logic
{
    public class CityIDWorker : BatchWorker
    {

        DataTable targetDT;

        private static DataTable ReadDtCity()
        {
            string sql = "select ID,CityName from city with(nolock)";
            return DAL.ReadDt_Retry_ReturnNewIfNull(DB.TaskReader, sql);
        }

        protected override void ReadData()
        {
            targetDT = ReadDtCity();
        }

        protected override void ProcessData()
        {

        }

        protected override void WriteData()
        {
            DAL.TVPUpdate(targetDT, "EstateManageUpdateCityID", "UdtEstateManageUpdateCityID");
        }
    }
}
